PC World 2008 February (DVD)/PCWorld_2008-02_DVD.iso/v cisle/PHP/PHP.exe/EasyPHP-2.0b1-setup.exe/{app}/sqlitemanager/include/sqlite.class.php

PHP Script | 2006-04-18 | 1.3 KB | 68 lines

<?php

class sqlite {

    var $dbPath;

    var $connId;

    var $error;

    var $errorMessage;

    var $readOnly;

    var $resId;

    var $dbVersion;

    function sqlite($dbPath) {
        $this->dbPath = $dbPath;

    }

    function isReadOnly() {
        return $this->readOnly;
    }

    function getVersion() {
        return $this->dbVersion;
    }

   function getConnId() {
        if(is_resource($this->connId) || is_object($this->connId)) {
            return $this->connId;
        } else {
            return false;
        }
    }

    function escape($string) {
        if(function_exists('sqlite_escape_string')) {
            $res = sqlite_escape_string($string);
        } else {
            $res = str_replace("'", "''", $string);
        }
        return $res;
    }

    /**
     * Get version number of SQLite database file
     *
     * @param string $fullPath full path with filename of the database file
     * @return version number or false
     */
    function getDbVersion($fullPath){
        if(!file_exists($fullPath)) $fullPath = DEFAULT_DB_PATH . $fullPath;
        $fp = @fopen($fullPath, 'r');
        if ($fp){
            $signature = fread($fp, 47);
            if($signature == "** This file contains an SQLite 2.1 database **") $dbVersion = 2;
            elseif(substr($signature, 0, 15) == "SQLite format 3") $dbVersion = 3;
            else $dbVersion = false;
            fclose($fp);
            return $dbVersion;
        }
    }
}
?>